<?php 
 include_once dirname(__FILE__)."/config.php";
 class enseignant extends enseignant_principal{
 
 public function SELECT_ENS($code_ue)
 {
 
 $sql=" SELECT 
           cin,
		   nom_enseig,
		   prenom_enseig,
		   tel_mobile,
		   tel,
		   fax,
		   mail ,
		   grade,
		   code_universite,
		   code_etablissement
		  
		  
          FROM enseignant
          WHERE cin
            IN (

               SELECT code_ens
               FROM ens_ue
               WHERE code_ue ='$code_ue'
               AND role != 'Responsable'
			   
	           )
	 ";		   

	$this->_result=$this->_cnn->query($sql);
	 if(!$this->_result){return 'erreur d\'execution de la requette';}else{return 'success';}
	}
	















	
}
?>